select ' INSERT INTO RANK(RANKNAME) VALUES (' 
+ '''' + ISNULL(RANKNAME,'') + ''')' from RANK ORDER BY RANKKEY 

